The Database API > Database API functions > MMDB.getColumnsOfTable()

 

MMDB.getColumnsOfTable()

Availability

Dreamweaver UltraDev 1.0

Description

Gets a list of all the columns in the specified table.

Arguments

connName, tableName

connName is the UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source.
tableName is the name of a table in the database specified by connName.

Returns

An array of strings; each string is the name of a column in the table.

Example

The statement MMDB.getColumnsOfTable ("EmpDB","Employees"); returns the following strings:

["EmpID", "FirstName", "LastName"]